Company Name
uk00000107
A
1
upper( contact1.company )
17:37
ContactID
contactid
2
3
City
uk00000105
upper( contact1.city )
State
uk00000106
upper( contact1.state )
ZIP Code
uk00000104
upper( contact1.zip )
Main Phone
uk00000110
upper( contact1.usmphone )
Account Status
uk00000111
upper( contact1.acctstatus )
Account Type
uk00000113
upper( contact1.accttype )
Type of Business
uk00000114
upper( contact1.typebus )
Contact First Name
uk00000115
upper( contact2.contact )
Office Phone
uk00000116
upper( contact2.usphone )
Account Representative
uk00000118
upper( contact2.acctrep )
Contract Date
uk00000122
contact3.condate
Order Amount
uk00000123
contact3.amtorder
Customer ID
uk00000127
upper( contact2.custid )